﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace VehicleConfigurator.NetUtils.Database
{
    public class FieldNames
    {
        public const string MAKE = "Make";
        public const string MODEL = "Model";
        public const string EDITION = "Edition";
        public const string DESCRIPTION = "Description";
        public const string GROUP = "Group";
        public const string CODE = "Code";
        public const string NAME = "Name";
        public const string PRICE_LIST_DATE = "PriceListDate";
        public const string ISDEFAULT = "IsDefault";
        public const string OID = "OID";
        public const string OID_MAKE = "MakeOID";
        public const string OID_COUNTRY = "CountryOID";
        public const string OID_CURRENCY = "CurrencyOID";
        public const string OID_MODEL = "ModelOID";
        public const string OID_MODEL_YEAR = "ModelYearOID";
        public const string OID_MODEL_EDITION = "ModelEditionOID";
        public const string OID_OPTION_GROUP = OID_GROUP;
        public const string OID_SUBMODEL = "SubModelOID";
        public const string OID_GROUP = "GroupOID";
        public const string OID_LANGUAGE = "LanguageOID";

        public const string OPTION_NAME = "OptionName";
        public const string OPTION_CODE = "OptionCode";
        public const string OPTION_PRICELIST_OID = "OptionpricelistOid";
        public const string BASE_NAME = "BaseName";
        public const string EXPLANATION = "Explanation";
        public const string LANGUAGE = "Language";
        public const string OPTION_OID = "OptionOid";
        public const string OID_OPTION = OPTION_OID;
        public const string OPTION_GROUP_PRICELIST = "OptionGroupPriceList";


        public const string MODEL_CODE = "ModelCode";
        public const string SUBMODEL_NAME = "SubModelName";

        // Pricing
        public const string PRICE_DEALER_NET = "DealerNetPrice";
        public const string PRICE_DEALER_NET_VAT = "DealerNetPriceVAT";
        public const string PRICE_RETAIL = "RetailPrice";
        public const string PRICE_RETAIL_VAT = "RetailPriceVAT";

        //vat
        public const string VAT_OID = "OID";
        public const string VAT_CODE = "Code";
        public const string VAT_NAME = "Name";
        public const string VAT_VATPC = "VATPC";

        //Country
        public const string COUNTRY_OID = "OID";
        public const string COUNTRY_NAME = "Name";
        public const string COUNTRY_CODE = "Code";
        public const string COUNTRY_IS_DEFAULT = "IsDefault";
        public const string VAT_DEFAULT = "VatDefault";

        //modelPrice ColumnName
        public const string RETAIL_PRICE= "RetailPrice";
        public const string RETAIL_PRICE_VAT = "RetailPriceVAT";
        public const string DEALER_NET_PRICE_VAT = "DealerNetPriceVAT";
        public const string DEALER_NET_PRICE= "DealerNetPrice";
        
        public const string CCM = "CylinderCapacity";
        public const string ENGINE_TYPE = "EngineType";
        public const string KW = "PowerKW";
        public const string GEAR = "GearBoxType";
        public const string CO2_MIN = "CO2EmissionMin";
        public const string CO2_MAX = "CO2EmissionMax";
        public const string CO2_AVG = "CO2EmissionAvg";
        public const string TAX1 = "TaxAmount1";
        public const string TAX2 = "TaxAmount2";
        public const string TAX3 = "TaxAmount3";

        public const string TAX1P = "TaxPercentage1";
        public const string TAX2P = "TaxPercentage2";
        public const string TAX3P = "TaxPercentage3";

        public const string EMISSION= "EmissionNorm";
        public const string FUEL = "FuelType";
        
        

        public static class Table
        {
            public const string SUBMODEL_PRICE = "submodelprice";
            public const string OPTION = "option";
            public const string OPTION_PRICE = "optionprice";
            public const string VAT = "vat";
            public const string COUNTRY = "country";

        }


    }
}
